Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 21613 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 5 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 2.8 MiB |
| Average record size in memory | 136.0 B |
Variable types
| NUM | 16 |
|---|---|
| BOOL | 1 |
Reproduction
| Analysis started | 2020-06-14 22:36:17.869117 |
|---|---|
| Analysis finished | 2020-06-14 22:37:12.592121 |
| Duration | 54.72 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 5 (< 0.1%) duplicate rows | Duplicates |
view has 19489 (90.2%) zeros | Zeros |
sqft_basement has 13126 (60.7%) zeros | Zeros |
age has 430 (2.0%) zeros | Zeros |
price
Real number (ℝ≥0)
| Distinct count | 4028 |
|---|---|
| Unique (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 540088.1417665294 |
|---|---|
| Minimum | 75000.0 |
| Maximum | 7700000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 75000 |
|---|---|
| 5-th percentile | 210000 |
| Q1 | 321950 |
| median | 450000 |
| Q3 | 645000 |
| 95-th percentile | 1156480 |
| Maximum | 7700000 |
| Range | 7625000 |
| Interquartile range (IQR) | 323050 |
Descriptive statistics
| Standard deviation | 367127.1965 |
|---|---|
| Coefficient of variation (CV) | 0.6797542255 |
| Kurtosis | 34.58554043 |
| Mean | 540088.1418 |
| Median Absolute Deviation (MAD) | 150000 |
| Skewness | 4.024069145 |
| Sum | 1.167292501e+10 |
| Variance | 1.347823784e+11 |
| Value | Count | Frequency (%) | |
| 450000 | 172 | 0.8% | |
| 350000 | 172 | 0.8% | |
| 550000 | 159 | 0.7% | |
| 500000 | 152 | 0.7% | |
| 425000 | 150 | 0.7% | |
| 325000 | 148 | 0.7% | |
| 400000 | 145 | 0.7% | |
| 375000 | 138 | 0.6% | |
| 300000 | 133 | 0.6% | |
| 525000 | 131 | 0.6% | |
| Other values (4018) | 20113 | 93.1% |
| Value | Count | Frequency (%) | |
| 75000 | 1 | < 0.1% | |
| 78000 | 1 | < 0.1% | |
| 80000 | 1 | < 0.1% | |
| 81000 | 1 | < 0.1% | |
| 82000 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7700000 | 1 | < 0.1% | |
| 7062500 | 1 | < 0.1% | |
| 6885000 | 1 | < 0.1% | |
| 5570000 | 1 | < 0.1% | |
| 5350000 | 1 | < 0.1% |
bedrooms
Real number (ℝ≥0)
| Distinct count | 13 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.37084162309721 |
|---|---|
| Minimum | 0 |
| Maximum | 33 |
| Zeros | 13 |
| Zeros (%) | 0.1% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.9300618311 |
|---|---|
| Coefficient of variation (CV) | 0.2759138325 |
| Kurtosis | 49.06365318 |
| Mean | 3.370841623 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.974299535 |
| Sum | 72854 |
| Variance | 0.8650150098 |
| Value | Count | Frequency (%) | |
| 3 | 9824 | 45.5% | |
| 4 | 6882 | 31.8% | |
| 2 | 2760 | 12.8% | |
| 5 | 1601 | 7.4% | |
| 6 | 272 | 1.3% | |
| 1 | 199 | 0.9% | |
| 7 | 38 | 0.2% | |
| 8 | 13 | 0.1% | |
| 0 | 13 | 0.1% | |
| 9 | 6 | < 0.1% | |
| Other values (3) | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 13 | 0.1% | |
| 1 | 199 | 0.9% | |
| 2 | 2760 | 12.8% | |
| 3 | 9824 | 45.5% | |
| 4 | 6882 | 31.8% |
| Value | Count | Frequency (%) | |
| 33 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10 | 3 | < 0.1% | |
| 9 | 6 | < 0.1% | |
| 8 | 13 | 0.1% |
bathrooms
Real number (ℝ≥0)
| Distinct count | 30 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1147573219821405 |
|---|---|
| Minimum | 0.0 |
| Maximum | 8.0 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1.75 |
| median | 2.25 |
| Q3 | 2.5 |
| 95-th percentile | 3.5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.7701631572 |
|---|---|
| Coefficient of variation (CV) | 0.3641851238 |
| Kurtosis | 1.279902444 |
| Mean | 2.114757322 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.5111075733 |
| Sum | 45706.25 |
| Variance | 0.5931512887 |
| Value | Count | Frequency (%) | |
| 2.5 | 5380 | 24.9% | |
| 1 | 3852 | 17.8% | |
| 1.75 | 3048 | 14.1% | |
| 2.25 | 2047 | 9.5% | |
| 2 | 1930 | 8.9% | |
| 1.5 | 1446 | 6.7% | |
| 2.75 | 1185 | 5.5% | |
| 3 | 753 | 3.5% | |
| 3.5 | 731 | 3.4% | |
| 3.25 | 589 | 2.7% | |
| Other values (20) | 652 | 3.0% |
| Value | Count | Frequency (%) | |
| 0 | 10 | < 0.1% | |
| 0.5 | 4 | < 0.1% | |
| 0.75 | 72 | 0.3% | |
| 1 | 3852 | 17.8% | |
| 1.25 | 9 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7.75 | 1 | < 0.1% | |
| 7.5 | 1 | < 0.1% | |
| 6.75 | 2 | < 0.1% | |
| 6.5 | 2 | < 0.1% |
sqft_living
Real number (ℝ≥0)
| Distinct count | 1038 |
|---|---|
| Unique (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2079.8997362698374 |
|---|---|
| Minimum | 290 |
| Maximum | 13540 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 940 |
| Q1 | 1427 |
| median | 1910 |
| Q3 | 2550 |
| 95-th percentile | 3760 |
| Maximum | 13540 |
| Range | 13250 |
| Interquartile range (IQR) | 1123 |
Descriptive statistics
| Standard deviation | 918.440897 |
|---|---|
| Coefficient of variation (CV) | 0.4415794093 |
| Kurtosis | 5.24309299 |
| Mean | 2079.899736 |
| Median Absolute Deviation (MAD) | 540 |
| Skewness | 1.471555427 |
| Sum | 44952873 |
| Variance | 843533.6814 |
| Value | Count | Frequency (%) | |
| 1300 | 138 | 0.6% | |
| 1400 | 135 | 0.6% | |
| 1440 | 133 | 0.6% | |
| 1010 | 129 | 0.6% | |
| 1660 | 129 | 0.6% | |
| 1800 | 129 | 0.6% | |
| 1820 | 128 | 0.6% | |
| 1480 | 125 | 0.6% | |
| 1720 | 125 | 0.6% | |
| 1540 | 124 | 0.6% | |
| Other values (1028) | 20318 | 94.0% |
| Value | Count | Frequency (%) | |
| 290 | 1 | < 0.1% | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 384 | 1 | < 0.1% | |
| 390 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13540 | 1 | < 0.1% | |
| 12050 | 1 | < 0.1% | |
| 10040 | 1 | < 0.1% | |
| 9890 | 1 | < 0.1% | |
| 9640 | 1 | < 0.1% |
sqft_lot
Real number (ℝ≥0)
| Distinct count | 9782 |
|---|---|
| Unique (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15106.967565816869 |
|---|---|
| Minimum | 520 |
| Maximum | 1651359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 520 |
|---|---|
| 5-th percentile | 1800 |
| Q1 | 5040 |
| median | 7618 |
| Q3 | 10688 |
| 95-th percentile | 43339.2 |
| Maximum | 1651359 |
| Range | 1650839 |
| Interquartile range (IQR) | 5648 |
Descriptive statistics
| Standard deviation | 41420.51152 |
|---|---|
| Coefficient of variation (CV) | 2.741815082 |
| Kurtosis | 285.0778197 |
| Mean | 15106.96757 |
| Median Absolute Deviation (MAD) | 2618 |
| Skewness | 13.06001896 |
| Sum | 326506890 |
| Variance | 1715658774 |
| Value | Count | Frequency (%) | |
| 5000 | 358 | 1.7% | |
| 6000 | 290 | 1.3% | |
| 4000 | 251 | 1.2% | |
| 7200 | 220 | 1.0% | |
| 4800 | 120 | 0.6% | |
| 7500 | 119 | 0.6% | |
| 4500 | 114 | 0.5% | |
| 8400 | 111 | 0.5% | |
| 9600 | 109 | 0.5% | |
| 3600 | 103 | 0.5% | |
| Other values (9772) | 19818 | 91.7% |
| Value | Count | Frequency (%) | |
| 520 | 1 | < 0.1% | |
| 572 | 1 | < 0.1% | |
| 600 | 1 | < 0.1% | |
| 609 | 1 | < 0.1% | |
| 635 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1651359 | 1 | < 0.1% | |
| 1164794 | 1 | < 0.1% | |
| 1074218 | 1 | < 0.1% | |
| 1024068 | 1 | < 0.1% | |
| 982998 | 1 | < 0.1% |
floors
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.4943089807060566 |
|---|---|
| Minimum | 1.0 |
| Maximum | 3.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 3.5 |
| Range | 2.5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.5399888951 |
|---|---|
| Coefficient of variation (CV) | 0.361363615 |
| Kurtosis | -0.4847229368 |
| Mean | 1.494308981 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.6161767212 |
| Sum | 32296.5 |
| Variance | 0.2915880069 |
| Value | Count | Frequency (%) | |
| 1 | 10680 | 49.4% | |
| 2 | 8241 | 38.1% | |
| 1.5 | 1910 | 8.8% | |
| 3 | 613 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 3.5 | 8 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 10680 | 49.4% | |
| 1.5 | 1910 | 8.8% | |
| 2 | 8241 | 38.1% | |
| 2.5 | 161 | 0.7% | |
| 3 | 613 | 2.8% |
| Value | Count | Frequency (%) | |
| 3.5 | 8 | < 0.1% | |
| 3 | 613 | 2.8% | |
| 2.5 | 161 | 0.7% | |
| 2 | 8241 | 38.1% | |
| 1.5 | 1910 | 8.8% |
waterfront
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 168.9 KiB |
| 0 | |
|---|---|
| 1 | 163 |
| Value | Count | Frequency (%) | |
| 0 | 21450 | 99.2% | |
| 1 | 163 | 0.8% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.23430342849211122 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 19489 |
| Zeros (%) | 90.2% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7663175693 |
|---|---|
| Coefficient of variation (CV) | 3.270620384 |
| Kurtosis | 10.89302168 |
| Mean | 0.2343034285 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.395749593 |
| Sum | 5064 |
| Variance | 0.587242617 |
| Value | Count | Frequency (%) | |
| 0 | 19489 | 90.2% | |
| 2 | 963 | 4.5% | |
| 3 | 510 | 2.4% | |
| 1 | 332 | 1.5% | |
| 4 | 319 | 1.5% |
| Value | Count | Frequency (%) | |
| 0 | 19489 | 90.2% | |
| 1 | 332 | 1.5% | |
| 2 | 963 | 4.5% | |
| 3 | 510 | 2.4% | |
| 4 | 319 | 1.5% |
| Value | Count | Frequency (%) | |
| 4 | 319 | 1.5% | |
| 3 | 510 | 2.4% | |
| 2 | 963 | 4.5% | |
| 1 | 332 | 1.5% | |
| 0 | 19489 | 90.2% |
condition
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4094295100171195 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.6507430464 |
|---|---|
| Coefficient of variation (CV) | 0.1908656696 |
| Kurtosis | 0.5257635653 |
| Mean | 3.40942951 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.032804637 |
| Sum | 73688 |
| Variance | 0.4234665124 |
| Value | Count | Frequency (%) | |
| 3 | 14031 | 64.9% | |
| 4 | 5679 | 26.3% | |
| 5 | 1701 | 7.9% | |
| 2 | 172 | 0.8% | |
| 1 | 30 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 30 | 0.1% | |
| 2 | 172 | 0.8% | |
| 3 | 14031 | 64.9% | |
| 4 | 5679 | 26.3% | |
| 5 | 1701 | 7.9% |
| Value | Count | Frequency (%) | |
| 5 | 1701 | 7.9% | |
| 4 | 5679 | 26.3% | |
| 3 | 14031 | 64.9% | |
| 2 | 172 | 0.8% | |
| 1 | 30 | 0.1% |
grade
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.656873178179799 |
|---|---|
| Minimum | 1 |
| Maximum | 13 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 7 |
| median | 7 |
| Q3 | 8 |
| 95-th percentile | 10 |
| Maximum | 13 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.175458757 |
|---|---|
| Coefficient of variation (CV) | 0.1535168116 |
| Kurtosis | 1.190932077 |
| Mean | 7.656873178 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.7711032008 |
| Sum | 165488 |
| Variance | 1.381703289 |
| Value | Count | Frequency (%) | |
| 7 | 8981 | 41.6% | |
| 8 | 6068 | 28.1% | |
| 9 | 2615 | 12.1% | |
| 6 | 2038 | 9.4% | |
| 10 | 1134 | 5.2% | |
| 11 | 399 | 1.8% | |
| 5 | 242 | 1.1% | |
| 12 | 90 | 0.4% | |
| 4 | 29 | 0.1% | |
| 13 | 13 | 0.1% | |
| Other values (2) | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 1 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 4 | 29 | 0.1% | |
| 5 | 242 | 1.1% | |
| 6 | 2038 | 9.4% |
| Value | Count | Frequency (%) | |
| 13 | 13 | 0.1% | |
| 12 | 90 | 0.4% | |
| 11 | 399 | 1.8% | |
| 10 | 1134 | 5.2% | |
| 9 | 2615 | 12.1% |
sqft_above
Real number (ℝ≥0)
| Distinct count | 946 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1788.3906907879516 |
|---|---|
| Minimum | 290 |
| Maximum | 9410 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 290 |
|---|---|
| 5-th percentile | 850 |
| Q1 | 1190 |
| median | 1560 |
| Q3 | 2210 |
| 95-th percentile | 3400 |
| Maximum | 9410 |
| Range | 9120 |
| Interquartile range (IQR) | 1020 |
Descriptive statistics
| Standard deviation | 828.0909777 |
|---|---|
| Coefficient of variation (CV) | 0.4630369538 |
| Kurtosis | 3.402303621 |
| Mean | 1788.390691 |
| Median Absolute Deviation (MAD) | 450 |
| Skewness | 1.446664473 |
| Sum | 38652488 |
| Variance | 685734.6673 |
| Value | Count | Frequency (%) | |
| 1300 | 212 | 1.0% | |
| 1010 | 210 | 1.0% | |
| 1200 | 206 | 1.0% | |
| 1220 | 192 | 0.9% | |
| 1140 | 184 | 0.9% | |
| 1400 | 180 | 0.8% | |
| 1060 | 178 | 0.8% | |
| 1180 | 177 | 0.8% | |
| 1340 | 176 | 0.8% | |
| 1250 | 174 | 0.8% | |
| Other values (936) | 19724 | 91.3% |
| Value | Count | Frequency (%) | |
| 290 | 1 | < 0.1% | |
| 370 | 1 | < 0.1% | |
| 380 | 1 | < 0.1% | |
| 384 | 1 | < 0.1% | |
| 390 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9410 | 1 | < 0.1% | |
| 8860 | 1 | < 0.1% | |
| 8570 | 1 | < 0.1% | |
| 8020 | 1 | < 0.1% | |
| 7880 | 1 | < 0.1% |
| Distinct count | 306 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 291.5090454818859 |
|---|---|
| Minimum | 0 |
| Maximum | 4820 |
| Zeros | 13126 |
| Zeros (%) | 60.7% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 560 |
| 95-th percentile | 1190 |
| Maximum | 4820 |
| Range | 4820 |
| Interquartile range (IQR) | 560 |
Descriptive statistics
| Standard deviation | 442.5750427 |
|---|---|
| Coefficient of variation (CV) | 1.518220616 |
| Kurtosis | 2.715574211 |
| Mean | 291.5090455 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.577965056 |
| Sum | 6300385 |
| Variance | 195872.6684 |
| Value | Count | Frequency (%) | |
| 0 | 13126 | 60.7% | |
| 600 | 221 | 1.0% | |
| 700 | 218 | 1.0% | |
| 500 | 214 | 1.0% | |
| 800 | 206 | 1.0% | |
| 400 | 184 | 0.9% | |
| 1000 | 149 | 0.7% | |
| 900 | 144 | 0.7% | |
| 300 | 142 | 0.7% | |
| 200 | 108 | 0.5% | |
| Other values (296) | 6901 | 31.9% |
| Value | Count | Frequency (%) | |
| 0 | 13126 | 60.7% | |
| 10 | 2 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 40 | 4 | < 0.1% | |
| 50 | 11 | 0.1% |
| Value | Count | Frequency (%) | |
| 4820 | 1 | < 0.1% | |
| 4130 | 1 | < 0.1% | |
| 3500 | 1 | < 0.1% | |
| 3480 | 1 | < 0.1% | |
| 3260 | 1 | < 0.1% |
lat
Real number (ℝ≥0)
| Distinct count | 5034 |
|---|---|
| Unique (%) | 23.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.56005251931708 |
|---|---|
| Minimum | 47.1559 |
| Maximum | 47.7776 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 47.1559 |
|---|---|
| 5-th percentile | 47.3103 |
| Q1 | 47.471 |
| median | 47.5718 |
| Q3 | 47.678 |
| 95-th percentile | 47.74964 |
| Maximum | 47.7776 |
| Range | 0.6217 |
| Interquartile range (IQR) | 0.207 |
Descriptive statistics
| Standard deviation | 0.1385637102 |
|---|---|
| Coefficient of variation (CV) | 0.002913447377 |
| Kurtosis | -0.6763130016 |
| Mean | 47.56005252 |
| Median Absolute Deviation (MAD) | 0.1049 |
| Skewness | -0.4852704765 |
| Sum | 1027915.415 |
| Variance | 0.0191999018 |
| Value | Count | Frequency (%) | |
| 47.5491 | 17 | 0.1% | |
| 47.6846 | 17 | 0.1% | |
| 47.6624 | 17 | 0.1% | |
| 47.5322 | 17 | 0.1% | |
| 47.6711 | 16 | 0.1% | |
| 47.6886 | 16 | 0.1% | |
| 47.6955 | 16 | 0.1% | |
| 47.686 | 15 | 0.1% | |
| 47.6647 | 15 | 0.1% | |
| 47.6904 | 15 | 0.1% | |
| Other values (5024) | 21452 | 99.3% |
| Value | Count | Frequency (%) | |
| 47.1559 | 1 | < 0.1% | |
| 47.1593 | 1 | < 0.1% | |
| 47.1622 | 1 | < 0.1% | |
| 47.1647 | 1 | < 0.1% | |
| 47.1764 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 47.7776 | 3 | < 0.1% | |
| 47.7775 | 3 | < 0.1% | |
| 47.7774 | 1 | < 0.1% | |
| 47.7772 | 3 | < 0.1% | |
| 47.7771 | 2 | < 0.1% |
long
Real number (ℝ)
| Distinct count | 752 |
|---|---|
| Unique (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.21389640494147 |
|---|---|
| Minimum | -122.51899999999999 |
| Maximum | -121.315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | -122.519 |
|---|---|
| 5-th percentile | -122.387 |
| Q1 | -122.328 |
| median | -122.23 |
| Q3 | -122.125 |
| 95-th percentile | -121.979 |
| Maximum | -121.315 |
| Range | 1.204 |
| Interquartile range (IQR) | 0.203 |
Descriptive statistics
| Standard deviation | 0.1408283424 |
|---|---|
| Coefficient of variation (CV) | -0.001152310388 |
| Kurtosis | 1.049500887 |
| Mean | -122.2138964 |
| Median Absolute Deviation (MAD) | 0.101 |
| Skewness | 0.8850529834 |
| Sum | -2641408.943 |
| Variance | 0.01983262202 |
| Value | Count | Frequency (%) | |
| -122.29 | 116 | 0.5% | |
| -122.3 | 111 | 0.5% | |
| -122.362 | 104 | 0.5% | |
| -122.291 | 100 | 0.5% | |
| -122.372 | 99 | 0.5% | |
| -122.363 | 99 | 0.5% | |
| -122.288 | 98 | 0.5% | |
| -122.357 | 96 | 0.4% | |
| -122.284 | 95 | 0.4% | |
| -122.365 | 94 | 0.4% | |
| Other values (742) | 20601 | 95.3% |
| Value | Count | Frequency (%) | |
| -122.519 | 1 | < 0.1% | |
| -122.515 | 1 | < 0.1% | |
| -122.514 | 1 | < 0.1% | |
| -122.512 | 1 | < 0.1% | |
| -122.511 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| -121.315 | 2 | < 0.1% | |
| -121.316 | 1 | < 0.1% | |
| -121.319 | 1 | < 0.1% | |
| -121.321 | 1 | < 0.1% | |
| -121.325 | 1 | < 0.1% |
sqft_living15
Real number (ℝ≥0)
| Distinct count | 777 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1986.552491556008 |
|---|---|
| Minimum | 399 |
| Maximum | 6210 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 399 |
|---|---|
| 5-th percentile | 1140 |
| Q1 | 1490 |
| median | 1840 |
| Q3 | 2360 |
| 95-th percentile | 3300 |
| Maximum | 6210 |
| Range | 5811 |
| Interquartile range (IQR) | 870 |
Descriptive statistics
| Standard deviation | 685.3913043 |
|---|---|
| Coefficient of variation (CV) | 0.3450154512 |
| Kurtosis | 1.59709581 |
| Mean | 1986.552492 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 1.108181276 |
| Sum | 42935359 |
| Variance | 469761.2399 |
| Value | Count | Frequency (%) | |
| 1540 | 197 | 0.9% | |
| 1440 | 195 | 0.9% | |
| 1560 | 192 | 0.9% | |
| 1500 | 181 | 0.8% | |
| 1460 | 169 | 0.8% | |
| 1580 | 167 | 0.8% | |
| 1610 | 166 | 0.8% | |
| 1800 | 166 | 0.8% | |
| 1720 | 166 | 0.8% | |
| 1620 | 165 | 0.8% | |
| Other values (767) | 19849 | 91.8% |
| Value | Count | Frequency (%) | |
| 399 | 1 | < 0.1% | |
| 460 | 2 | < 0.1% | |
| 620 | 2 | < 0.1% | |
| 670 | 1 | < 0.1% | |
| 690 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6210 | 1 | < 0.1% | |
| 6110 | 1 | < 0.1% | |
| 5790 | 6 | < 0.1% | |
| 5610 | 1 | < 0.1% | |
| 5600 | 1 | < 0.1% |
sqft_lot15
Real number (ℝ≥0)
| Distinct count | 8689 |
|---|---|
| Unique (%) | 40.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12768.455651691113 |
|---|---|
| Minimum | 651 |
| Maximum | 871200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | 651 |
|---|---|
| 5-th percentile | 1999.2 |
| Q1 | 5100 |
| median | 7620 |
| Q3 | 10083 |
| 95-th percentile | 37062.8 |
| Maximum | 871200 |
| Range | 870549 |
| Interquartile range (IQR) | 4983 |
Descriptive statistics
| Standard deviation | 27304.17963 |
|---|---|
| Coefficient of variation (CV) | 2.138408933 |
| Kurtosis | 150.76311 |
| Mean | 12768.45565 |
| Median Absolute Deviation (MAD) | 2505 |
| Skewness | 9.506743247 |
| Sum | 275964632 |
| Variance | 745518225.3 |
| Value | Count | Frequency (%) | |
| 5000 | 427 | 2.0% | |
| 4000 | 357 | 1.7% | |
| 6000 | 289 | 1.3% | |
| 7200 | 211 | 1.0% | |
| 4800 | 145 | 0.7% | |
| 7500 | 142 | 0.7% | |
| 8400 | 116 | 0.5% | |
| 3600 | 111 | 0.5% | |
| 4500 | 111 | 0.5% | |
| 5100 | 109 | 0.5% | |
| Other values (8679) | 19595 | 90.7% |
| Value | Count | Frequency (%) | |
| 651 | 1 | < 0.1% | |
| 659 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% | |
| 748 | 2 | < 0.1% | |
| 750 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 871200 | 1 | < 0.1% | |
| 858132 | 1 | < 0.1% | |
| 560617 | 1 | < 0.1% | |
| 438213 | 1 | < 0.1% | |
| 434728 | 1 | < 0.1% |
| Distinct count | 117 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.31781797991949 |
|---|---|
| Minimum | -1 |
| Maximum | 115 |
| Zeros | 430 |
| Zeros (%) | 2.0% |
| Memory size | 168.9 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 18 |
| median | 40 |
| Q3 | 63 |
| 95-th percentile | 99 |
| Maximum | 115 |
| Range | 116 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 29.3754928 |
|---|---|
| Coefficient of variation (CV) | 0.6781387931 |
| Kurtosis | -0.6579831918 |
| Mean | 43.31781798 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.4691624259 |
| Sum | 936228 |
| Variance | 862.9195775 |
| Value | Count | Frequency (%) | |
| 9 | 473 | 2.2% | |
| 8 | 443 | 2.0% | |
| 11 | 433 | 2.0% | |
| 0 | 430 | 2.0% | |
| 10 | 428 | 2.0% | |
| 7 | 400 | 1.9% | |
| 37 | 389 | 1.8% | |
| 36 | 381 | 1.8% | |
| 47 | 367 | 1.7% | |
| 46 | 343 | 1.6% | |
| Other values (107) | 17526 | 81.1% |
| Value | Count | Frequency (%) | |
| -1 | 12 | 0.1% | |
| 0 | 430 | 2.0% | |
| 1 | 285 | 1.3% | |
| 2 | 174 | 0.8% | |
| 3 | 165 | 0.8% |
| Value | Count | Frequency (%) | |
| 115 | 26 | 0.1% | |
| 114 | 69 | 0.3% | |
| 113 | 28 | 0.1% | |
| 112 | 33 | 0.2% | |
| 111 | 50 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | lat | long | sqft_living15 | sqft_lot15 | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 221900.0 | 3 | 1.00 | 1180 | 5650 | 1.0 | 0 | 0 | 3 | 7 | 1180 | 0 | 47.5112 | -122.257 | 1340 | 5650 | 59 |
| 1 | 538000.0 | 3 | 2.25 | 2570 | 7242 | 2.0 | 0 | 0 | 3 | 7 | 2170 | 400 | 47.7210 | -122.319 | 1690 | 7639 | 63 |
| 2 | 180000.0 | 2 | 1.00 | 770 | 10000 | 1.0 | 0 | 0 | 3 | 6 | 770 | 0 | 47.7379 | -122.233 | 2720 | 8062 | 82 |
| 3 | 604000.0 | 4 | 3.00 | 1960 | 5000 | 1.0 | 0 | 0 | 5 | 7 | 1050 | 910 | 47.5208 | -122.393 | 1360 | 5000 | 49 |
| 4 | 510000.0 | 3 | 2.00 | 1680 | 8080 | 1.0 | 0 | 0 | 3 | 8 | 1680 | 0 | 47.6168 | -122.045 | 1800 | 7503 | 28 |
| 5 | 1225000.0 | 4 | 4.50 | 5420 | 101930 | 1.0 | 0 | 0 | 3 | 11 | 3890 | 1530 | 47.6561 | -122.005 | 4760 | 101930 | 13 |
| 6 | 257500.0 | 3 | 2.25 | 1715 | 6819 | 2.0 | 0 | 0 | 3 | 7 | 1715 | 0 | 47.3097 | -122.327 | 2238 | 6819 | 19 |
| 7 | 291850.0 | 3 | 1.50 | 1060 | 9711 | 1.0 | 0 | 0 | 3 | 7 | 1060 | 0 | 47.4095 | -122.315 | 1650 | 9711 | 52 |
| 8 | 229500.0 | 3 | 1.00 | 1780 | 7470 | 1.0 | 0 | 0 | 3 | 7 | 1050 | 730 | 47.5123 | -122.337 | 1780 | 8113 | 55 |
| 9 | 323000.0 | 3 | 2.50 | 1890 | 6560 | 2.0 | 0 | 0 | 3 | 7 | 1890 | 0 | 47.3684 | -122.031 | 2390 | 7570 | 12 |
Last rows
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | lat | long | sqft_living15 | sqft_lot15 | age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21603 | 507250.0 | 3 | 2.50 | 2270 | 5536 | 2.0 | 0 | 0 | 3 | 8 | 2270 | 0 | 47.5389 | -121.881 | 2270 | 5731 | 11 |
| 21604 | 429000.0 | 3 | 2.00 | 1490 | 1126 | 3.0 | 0 | 0 | 3 | 8 | 1490 | 0 | 47.5699 | -122.288 | 1400 | 1230 | 1 |
| 21605 | 610685.0 | 4 | 2.50 | 2520 | 6023 | 2.0 | 0 | 0 | 3 | 9 | 2520 | 0 | 47.5137 | -122.167 | 2520 | 6023 | 0 |
| 21606 | 1007500.0 | 4 | 3.50 | 3510 | 7200 | 2.0 | 0 | 0 | 3 | 9 | 2600 | 910 | 47.5537 | -122.398 | 2050 | 6200 | 6 |
| 21607 | 475000.0 | 3 | 2.50 | 1310 | 1294 | 2.0 | 0 | 0 | 3 | 8 | 1180 | 130 | 47.5773 | -122.409 | 1330 | 1265 | 7 |
| 21608 | 360000.0 | 3 | 2.50 | 1530 | 1131 | 3.0 | 0 | 0 | 3 | 8 | 1530 | 0 | 47.6993 | -122.346 | 1530 | 1509 | 5 |
| 21609 | 400000.0 | 4 | 2.50 | 2310 | 5813 | 2.0 | 0 | 0 | 3 | 8 | 2310 | 0 | 47.5107 | -122.362 | 1830 | 7200 | 1 |
| 21610 | 402101.0 | 2 | 0.75 | 1020 | 1350 | 2.0 | 0 | 0 | 3 | 7 | 1020 | 0 | 47.5944 | -122.299 | 1020 | 2007 | 5 |
| 21611 | 400000.0 | 3 | 2.50 | 1600 | 2388 | 2.0 | 0 | 0 | 3 | 8 | 1600 | 0 | 47.5345 | -122.069 | 1410 | 1287 | 11 |
| 21612 | 325000.0 | 2 | 0.75 | 1020 | 1076 | 2.0 | 0 | 0 | 3 | 7 | 1020 | 0 | 47.5941 | -122.299 | 1020 | 1357 | 6 |
Most frequent
| price | bedrooms | bathrooms | sqft_living | sqft_lot | floors | waterfront | view | condition | grade | sqft_above | sqft_basement | lat | long | sqft_living15 | sqft_lot15 | age | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 259950.0 | 2 | 2.00 | 1070 | 649 | 2.0 | 0 | 0 | 3 | 9 | 720 | 350 | 47.5213 | -122.357 | 1070 | 928 | 7 | 2 |
| 1 | 529500.0 | 3 | 2.25 | 1410 | 905 | 3.0 | 0 | 0 | 3 | 9 | 1410 | 0 | 47.5818 | -122.402 | 1510 | 1352 | 1 | 2 |
| 2 | 550000.0 | 4 | 1.75 | 2410 | 8447 | 2.0 | 0 | 3 | 4 | 8 | 2060 | 350 | 47.6499 | -122.088 | 2520 | 14789 | 78 | 2 |
| 3 | 555000.0 | 3 | 2.50 | 1940 | 3211 | 2.0 | 0 | 0 | 3 | 8 | 1940 | 0 | 47.5644 | -122.093 | 1880 | 3078 | 5 | 2 |
| 4 | 635000.0 | 3 | 3.00 | 2230 | 1407 | 2.5 | 0 | 0 | 3 | 8 | 1850 | 380 | 47.5446 | -122.017 | 2290 | 1407 | 1 | 2 |